hi , i designed a simple ETL package in SSIS which is extracting data from the flat file and loding it into SQL Server table, now what i want that if i get error during extraction in any column due to data inconsistance (suppose datetime column have int value in csv file), then how can i get that column value into variable which has inconsistance value. please assist its very urgent. thanks a lot in advance Regards, Amitesh Srivastva

you should Configure Error Output for the destination, this link will help you in this way: http://www.rad.pasfu.com/index.php?/archives/23-How-to-handle-Failed-Rows-in-a-Data-Flow.htmlhttp://www.rad.pasfu.com

many thanks Reza.... :) link is really very useful to me

hi , please guide me in the given link. http://www.rad.pasfu.com/index.php?/archives/23-How-to-handle-Failed-Rows-in-a-Data-Flow.html if i want to log just error rows in ErrorLog Table in other words if i want to change it like, as after error occurs all error Rows(which conflecting constraint violation) sould come in ErrorRows Table but DestinationFailure stop loading data in DestinationFailure sorry for my poor english if its so. :(

hi , please guide me in the given link. http://www.rad.pasfu.com/index.php?/archives/23-How-to-handle-Failed-Rows-in-a-Data-Flow.html what i need to do if i want to log just error rows in ErrorLog Table only , in other words if i want to change it like, as after error occurs all error Rows(which conflecting constraint violation) sould come in ErrorRows Table but DestinationFailure stop loading data in DestinationFailure sorry for my poor english if its so. :( Thanks and Regards, Amitesh

when you work with failure output in oledb destination, you can do it in these ways: 1-Transfer data to oledb destination will fail on error, and all error rows transfer to ErrorLog table , (in this way if only one row has error, there will be no rows trasnfered to oledb destinaiton) 2- Transfer data to oledb destination will succeed , but only error rows will transfer to ErrorLog in the given link , second way implemented. but if you want to implement first way, right click on OLE DB Destination, select properties window. find AccessMode in properties, change the AccessMode value to "OpenRowSet using FastLoad" let me know if you have any question yet. http://www.rad.pasfu.com

Many Thanks Reza, for your kind assistance and guidance :) but if i set OLEDB Destination property Access Mode to "OpenRowSet using FastLoad" then it shows error that OLEDB Destination Input can not be set to redirect the row when the fast load option is turned on, So now how can i collect the error row value in to the table or value.... Problem: i was looking for error row value due to which the ETL getting failed and package sould stop after catching the error value in to variable or in to any DB table.